////////////////////////////////////////////////////////////////////////////////
//                                                                            //
// The MIT License (MIT)                                                      //
//                                                                            //
// Copyright (c) 2013 Charles Teague                                          //
//                                                                            //
// Permission is hereby granted, free of charge, to any person obtaining a    //
// copy of this software and associated documentation files (the "Software"), //
// to deal in the Software without restriction, including without limitation  //
// the rights to use, copy, modify, merge, publish, distribute, sublicense,   //
// and/or sell copies of the Software, and to permit persons to whom the      //
// Software is furnished to do so, subject to the following conditions:       //
//                                                                            //
// The above copyright notice and this permission notice shall be included in //
// all copies or substantial portions of the Software.                        //
//                                                                            //
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR //
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,   //
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL    //
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER //
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING    //
// FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER        //
// DEALINGS IN THE SOFTWARE.                                                  //
//                                                                            //
////////////////////////////////////////////////////////////////////////////////
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using RPSDAL;
using RPSDAL.EntityClasses;
using RPSDAL.DaoClasses;
using RPSDAL.FactoryClasses;
using RPSDAL.HelperClasses;
using RPSDAL.CollectionClasses;

using SD.LLBLGen.Pro.ORMSupportClasses;

public partial class SummaryReport : System.Web.UI.Page
{
    protected override void OnInit(EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (Parameters.LoggedUser != -1)
            {
                UserEntity eUser = new UserEntity(Parameters.LoggedUser);
                RoleEntity eRole = new RoleEntity(eUser.RoleId);

                if (!eRole.HasSummaryReport)
                {
                    Parameters.LoggedUser = -1;
                    Response.Redirect("Default.aspx");
                    return;
                }
            }
        }

        grdCalls.PageSize = Parameters.PageSize;
        GetSummaryReport();
    }

    private void GetSummaryReport()
    {
        DataTable dtFields = new DataTable();
        ResultsetFields fields = new ResultsetFields(3);

        fields.DefineField(UserFieldIndex.UserId, 0, "UserId");
        fields.DefineField(UserFieldIndex.ConnectName, 1, "ConnectName", "User");
        fields.DefineField(CallFieldIndex.UserId, 2, "Calls", "", AggregateFunction.Count);


        RelationCollection relations = new RelationCollection();
        relations.Add(UserEntity.Relations.CallEntityUsingUserId, JoinHint.Left);

        IGroupByCollection groupByClause = new GroupByCollection();
        groupByClause.Add(fields[0]);
        groupByClause.Add(fields[1]);



        TypedListDAO dao = new TypedListDAO();
        dao.GetMultiAsDataTable(fields, dtFields, 0, null, null, relations, false, groupByClause, null, 0, 0);

        for (int i = 0; i < dtFields.Rows.Count; i++)
        {
            CallCollection cCalls = new CallCollection();
            IPredicateExpression filter = new PredicateExpression();
            filter.Add(CallFields.Done != true);
            filter.Add(CallFields.UserId == Convert.ToInt32(dtFields.Rows[i][0]));
            dtFields.Rows[i][2] = cCalls.GetDbCount(filter);
        }

        grdCalls.DataSource = dtFields;
        grdCalls.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
    }


    protected void grdCalls_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        grdCalls.PageIndex = e.NewPageIndex;
        GetSummaryReport();
    }
}
